 declare @OpUserName varchar(256),
@TreeID varchar(256),
@OldPTreeID int,
@NewPTreeID int,
@FilterTreeID varchar(8000),
@NewTreeID int

set @OpUserName='qsw'
set @TreeID=170
set @OldPTreeID=155
set @NewPTreeID=154
set @FilterTreeID='(170)(171)(175)(177)'

exec spm_GetFullTree_Debug @TreeID

exec spm_GetFullTree_Debug @NewPTreeID

exec spm_CopyTree @OpUserName,@TreeID,@OldPTreeID,@NewPTreeID,@FilterTreeID,@NewTreeID output

exec spm_GetFullTree_Debug @NewPTreeID
print @NewTreeID


